-- @owner: zou_jialiang050
-- @date: 2024/4/2
-- @testpoint: analyse作为函数名

--step1:建表;expect:成功drop table if exists t_analyse_0007;create table t_analyse_0007(cid int);--step2:analyse作为函数名;expect:成功drop function if exists analyse;create function analyse(card_id int) returns char(50) as$$declare num int := 0;beginwhile num<=card_id loopinsert into t_analyse_0007 values(num);num := num+1;end loop;return card_id;end;$$ language plpgsql;/select analyse(3);select * from t_analyse_0007;--step3:清理环境;expect:成功drop function if exists analyse;drop table if exists t_analyse_0007;